The following appendices detail the relevant fields in ebs that are mapped for the export files for the SDR return:
Student file - SDR
The fields in ebs that are mapped for the Student file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 1.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 1.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 1.3 | GENDER | Gender | 1 | PEOPLE.SEX | |
| 1.4 | DOB | Date of Birth | 8 | PEOPLE.DATE_OF_BIRTH | DDMMYYYY |
| 1.5 | (removed) | (padded blanks) | 6 | ||
| 1.6 | NAMEID | Name ID Code | 5 | Not stored – always calculated | See Definition of
EBS_LEARNERS. NAMEIDCODE |
| 1.7 | PRIOR_A | Main Activity at 1 October in Year Prior to Formal Enrolment | 2 | PEOPLE.PRIOR_LEARNER_STATUS | Right Justify |
| 1.8 | FIRST_YR | First Year of Formal Tertiary Education | 4 | PEOPLE.FIRST_TERTIARY_YEAR | |
| 1.9 | DIS_ACCESS | Disability Services Accessed Indicator | 1 | PEOPLE.DIS_ACCESSED | Convert Y = 1, N = 2 |
| 1.10 | S_SCHOOL | Last Secondary School Attended | 4 | PEOPLE.SCHOOL | Right Justify |
| 1.11 | Y_SCHOOL | Last Year of Secondary School | 4 | PEOPLE.LAST_SCHOOL_YEAR | |
| 1.12 | SEC_QUAL | Highest Secondary School Qualification | 2 | PEOPLE.SECONDARY_QUALIFICATION | Left Justify |
| 1.13 | CITIZEN | Country of Citizenship | 3 | PEOPLE.NATIONALITY | Fill character 9 |
| 1.14 | (removed) | (padded blanks) | 2 | ||
| 1.15 | DISABILITY | Disability Indicator | 1 | PEOPLE.DISABILITY | Fill character 9 |
| 1.16 | FINISH | Expectation to Complete a Qualification this year | 1 | PEOPLE.FINISH_THIS_YEAR | |
| 1.17 | IWI | Iwi Affiliation | 12 | PEOPLE.IWI_1, IWI_2 and IWI_3 | Left Justify |
| 1.18 | (removed) | (padded blanks) | 9 | ||
| 1.19 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 1.20 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'Y' THEN Sum (FEES_LIST.AMOUNT) where PEOPLE.NZ_FUNDING lookup VERIFIER (domain FUNDING). OPS_MASTER = '1' (International) FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' For fees relating to the learner's relevant enrolments |
Right Justify |
| 1.21 | MAX_Exempt_Fee | Maxima Exempt Fees | 5 |
Sum (FEES_LIST.AMOUNT) where FEES_LIST.FEE_DATE in return year and FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'E' FEE TYPES.INCLUDE_IN_RETURN = 'Y' |
Includes GST Right Justify |
| 1.22 | ETHNIC | Ethnicity | 9 | PEOPLE.NZ_ETHNICITY_1, NZ_ETHNICITY_2, NZ_ETHNICITY_3 | Left Justify |
| 1.23 | PERM_POST_CODE | Permanent Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_PERM_PCODE') | Fill character 8 |
| 1.24 | TERM_POST_CODE | Term Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_TERM_PCODE') | Fill character 8 |
Course Enrolment file - SDR
The fields in ebs that are mapped for the Course Enrolment file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 2.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 2.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 2.3 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE. Taken from parent qualification, or use 'home' qual code if more than one parent. | Left Justify |
| 2.4 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 2.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_START_DATE |
DDMMYYYY |
| 2.6 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_END_DATE |
DDMMYYYY |
| 2.7 | CRS_WTD | Student's Course Withdrawal Date | 8 | PEOPLE_UNITS.PROGRESS_DATE if PEOPLE_UNITS.PROGRESS_STATUS = 'W' | DDMMYYYY |
| 2.8 | ASSIST | Category of Fees Assessment for International Students | 2 | PEOPLE_UNITS.NZ_ASSIST | |
| 2.9 | ATTEND | Intramural/Extramural Attendance | 1 | PEOPLE_UNITS.ATTENDANCE_CODE | |
| 2.10 | CRS_SITE | Course Delivery Site | 2 |
Determine location from PEOPLE_UNITS.LOCATION_CODE, if null from UNIT_INSTANCES_OCCURRENCES.SLOC_LOCATION_CODE Lookup code from LOCATIONS.SITE_CODE |
|
| 2.11 | FUNDING | Source of Funding | 2 |
PEOPLE_UNITS.NZ_FUNDING if not null PEOPLE.NZ_FUNDING |
|
| 2.12 | RESIDENCY | Residential Status | 1 | Use PEOPLE_UNITS.RESIDENTIAL_STATUS to lookup VERIFIERS.OPS_MASTER where RV_DOMAIN = 'RESIDENTIAL_STATUS' - should be Y or N if null, use PEOPLE.RESIDENTIAL_STATUS | |
| 2.13 | AUS_RESIDENCY | Australian Residential Status | 1 | PEOPLE_UNITS.RESIDENTIAL_STATUS_2 | |
| 2.13.1 | MANAAPPR | Managed Apprenticeship |
1 | PEOPLE_UNITS.ENROLLED_AS_MGD_APPSHIP | |
| 2.14 | CATEGORY | Funding Category | 2 |
PEOPLE_UNITS_SPECIAL.FUNDING_CATEGORY and PEOPLE_UNITS_SPECIAL.FUNDING_STATUS (If PEOPLE_UNITS_SPECIAL.DETAILS = 'Y' or UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS |
|
| 2.15 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
| 2.16 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
| 2.17 | FACTOR | Course EFTS Factor | 6 |
PEOPLE_UNITS_SPECIAL.COURSE_EFTS_FACTOR (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR |
|
| 2.18 | EFTS_MTH | EFTS by Month | 84 |
UIO_EFTS.EFTS_MONTH_01-12 and PEOPLE_UNITS_SPECIAL_EFTS.EFTS_MONTH_01-12 for rows that apply to the academic year being reported |
6 chars x12. Numeric with 4 d.p. e.g. 0.0100 |
| 2.19 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
Course Register file - SDR
The fields in ebs that are mapped for the Course Register file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 3.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 3.2 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 3.3 | CTITLE | Course Title | 75 | UNIT_INSTANCE_OCCURRENCES.LONG_DESCRIPTION if not null else UNIT_INSTANCES.FES_LONG_DESCRIPTION |
Left Justify Truncate to 75 chars |
| 3.4 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE |
This is the 'home' qualification code. Left Justify |
| 3.5 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
| 3.6 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
| 3.7 | REGISTERLEVEL | Level on the NZ Register of Quality Assured Qualifications | 1 | UNIT_INSTANCES.SDR_REGISTER_LEVEL | |
| 3.8 | CREDIT | Credit | 3 | UNIT_INSTANCES.COURSE_CREDITS | |
| 3.9 | CATEGORY | Funding Category | 2 | UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS | |
| 3.10 | FACTOR | Course EFTS Factor |
6 | UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR | |
| 3.11 | STAGE | Stage of Pre-Service Teacher Education Qualification | 2 | UNIT_INSTANCES.QUALIFICATION_STAGE | |
| 3.12 | FEE | Course Tuition Fee | 5 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
| 3.13 | INTERNET | Internet Based Learning Indicator | 1 | UNIT_INSTANCES.INTERNET_BASED_LEARNING | |
| 3.14 | PBRF Eligible | PBRF Eligible Course Indicator | 1 | UNIT_INSTANCES.SDR_PBRF_ELIGIBLE | |
| 3.15 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'N' THEN Sum (FEE_VALUES.OVERSEAS_AMOUNT) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year or are null |
GST not included Right Justify |
| 3.16 | CCCOSTS Fee | Compulsory Course Costs Fee | 5 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'C' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
| 3.17 | EXEMPT Indicator | Course Exemption from FCCM | 1 | UNIT_INSTANCES.EXEMPT_INDICATOR | |
| 3.18 | EMB_LIT_NUM | Embedded Literacy and Numeracy Flag | 1 | UNIT_INSTANCES.EMBEDDED_LITERACY_NUMERACY |
Qualification Completion file- SDR
The fields in ebs that are mapped for the Qualification Completion file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 4.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 4.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 4.3 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 4.4 | QUAL | Qualification Code | 6 |
ATTAINMENTS.SDR_QUALIFICATION_CODE if not null UNIT_INSTANCES.SDR_QUALIFICATION_CODE via PEOPLE_UNITS.UIO_ID of ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
| 4.5 | MAIN_1 | Main Subject 1 | 4 |
ATTAINMENTS.MAIN_SUBJECT_1 if not null UNIT_INSTANCES.MAIN_SUBJECT_1 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
| 4.6 | MAIN_2 | Main Subject 2 | 4 |
ATTAINMENTS.MAIN_SUBJECT_2 if not null UNIT_INSTANCES.MAIN_SUBJECT_2 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
| 4.7 | MAIN_3 | Main Subject 3 | 4 |
ATTAINMENTS.MAIN_SUBJECT_3 if not null UNIT_INSTANCES.MAIN_SUBJECT_3 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
| 4.8 | YR_REQ_MET | Year Requirements Met | 4 | ATTAINMENTS.YEAR_REQUIREMENTS_MET | YYYY |
| 4.9 | (removed) | (padded blanks) | 4 |
Course Completion file - SDR
The fields in ebs that are mapped for the Course Completion file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 5.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 5.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 5.3 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 5.4 | COMPLETE | Student Course Completion indicator | 1 |
PROGRESS_CODES.SDR_COMPLETION_INDICATOR for record linked to PEOPLE_UNITS.PROGRESS_CODE If code is '0or1' then use '1' if Extract Date <= CRS_END else '0' |
|
| 5.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_START_DATE |
DDMMYYYY |
| 5.6 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 5.7 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_END_DATE |
DDMMYYYY |
| 5.8 | PBRF_CRS_COMP_YR | PBRF Course Completion Year | 4 | IF COMPLETE is 2 or 3 and UNIT_INSTANCES.SDR_PBRF_ELIGIBLE is not blank or 'X' then Year component of PEOPLE_UNITS.PROGRESS_DATE | YYYY |
The following appendices detail the relevant fields in ebs that are mapped for the export files for the SDR 2025+ return type:
Leaner file - SDR 2025+
The fields in ebs that are mapped for the Student file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 1.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 1.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 1.3 | GENDER | Gender | 1 | PEOPLE.SEX | |
| 1.4 | DOB | Date of Birth | 8 | PEOPLE.DATE_OF_BIRTH | DD/MM/YYYY |
| 1.5 | TOTAL_FEE | Total fee for Domestic Student | 10 | ||
| 1.6 | NAMEID | Name ID Code | 5 | Not stored – always calculated | See Definition of
EBS_LEARNERS. NAMEIDCODE |
| 1.7 | PRIOR_A | Main Activity at 1 October in Year Prior to Formal Enrolment | 2 | PEOPLE.PRIOR_LEARNER_STATUS | Right Justify |
| 1.8 | FIRST_YR | First Year of Formal Tertiary Education | 4 | PEOPLE.FIRST_TERTIARY_YEAR | |
| 1.9 | DIS_ACCESS | Disability Services Accessed Indicator | 1 | PEOPLE.DIS_ACCESSED | Convert Y = 1, N = 2 |
| 1.10 | S_SCHOOL | Last Secondary School Attended | 4 | PEOPLE.SCHOOL | Right Justify |
| 1.11 | Y_SCHOOL | Last Year of Secondary School | 4 | PEOPLE.LAST_SCHOOL_YEAR | |
| 1.12 | SEC_QUAL | Highest Secondary School Qualification | 2 | PEOPLE.SECONDARY_QUALIFICATION | Left Justify |
| 1.13 | CITIZEN | Country of Citizenship | 3 | PEOPLE.NATIONALITY | Fill character 9 |
| 1.14 | FINISH | Expectation to Complete a Qualification this year | 1 | PEOPLE.FINISH_THIS_YEAR | |
| 1.15 | IWI | Iwi Affiliation | 77 | PEOPLE.IWI_1, IWI_2, IWI_3, IWI_4, IWI_5, and IWI_6 | Left Justify |
| 1.16 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 1.17 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'Y' THEN Sum (FEES_LIST.AMOUNT) where PEOPLE.NZ_FUNDING lookup VERIFIER (domain FUNDING). OPS_MASTER = '1' (International) FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' For fees relating to the learner's relevant enrolments |
Right Justify |
| 1.18 | MAX_Exempt_Fee | Maxima Exempt Fees | 5 |
Sum (FEES_LIST.AMOUNT) where FEES_LIST.FEE_DATE in return year and FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'E' FEE TYPES.INCLUDE_IN_RETURN = 'Y' |
Includes GST Right Justify |
| 1.19 | ETHNIC | Ethnicity | 18 | PEOPLE.NZ_ETHNICITY_1, NZ_ETHNICITY_2, NZ_ETHNICITY_3, NZ_ETHNICITY_4, NZ_ETHNICITY_5, and NZ_ETHNICITY_6 | Left Justify |
| 1.20 | PERM_POST_CODE | Permanent Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_PERM_PCODE') | Fill character 8 |
| 1.21 | TERM_POST_CODE | Term Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_TERM_PCODE') | Fill character 8 |
| 1.22 | DISABILITY_STATUS | Disability Status | 1 | ||
| 1.23 | DISABILITY_SUPPORT_NEEDS | Disability Support Needs | 28 | PEOPLE.DISAB_1, DISAB_2, DISAB_3, DISAB_4, DISAB_5, DISAB_6 and DISAB_7 | |
| 1.24 | IRD_NUMBER | IRD Number | 9 | IRD_NO | Note that if the IRD number is only 8 digits, then a leading zero will be added to the output. Hyphens are also added in the output. |
Course Enrolment file - SDR 2025+
The fields in ebs that are mapped for the Course Enrolment file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 2.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 2.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 2.3 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE. Taken from parent qualification, or use 'home' qual code if more than one parent. | Left Justify |
| 2.4 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 2.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_START_DATE |
DDMMYYYY |
| 2.6 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_END_DATE |
DDMMYYYY |
| 2.7 | CRS_WTD | Student's Course Withdrawal Date | 8 | PEOPLE_UNITS.PROGRESS_DATE if PEOPLE_UNITS.PROGRESS_STATUS = 'W' | DDMMYYYY |
| 2.8 | ASSIST | Category of Fees Assessment for International Students | 2 | PEOPLE_UNITS.NZ_ASSIST | |
| 2.9 | ATTEND | Intramural/Extramural Attendance | 1 | PEOPLE_UNITS.ATTENDANCE_CODE | |
| 2.10 | CRS_SITE | Course Delivery Site | 2 |
Determine location from PEOPLE_UNITS.LOCATION_CODE, if null from UNIT_INSTANCES_OCCURRENCES.SLOC_LOCATION_CODE Lookup code from LOCATIONS.SITE_CODE |
|
| 2.11 | FUNDING | Source of Funding | 2 |
PEOPLE_UNITS.NZ_FUNDING if not null PEOPLE.NZ_FUNDING |
|
| 2.12 | RESIDENCY | Residential Status | 1 | Use PEOPLE_UNITS.RESIDENTIAL_STATUS to lookup VERIFIERS.OPS_MASTER where RV_DOMAIN = 'RESIDENTIAL_STATUS' - should be Y or N if null, use PEOPLE.RESIDENTIAL_STATUS | |
| 2.13 | AUS_RESIDENCY | Australian Residential Status | 1 | PEOPLE_UNITS.RESIDENTIAL_STATUS_2 | |
| 2.13.1 | CATEGORY | Funding Category | 2 |
PEOPLE_UNITS_SPECIAL.FUNDING_CATEGORY and PEOPLE_UNITS_SPECIAL.FUNDING_STATUS (If PEOPLE_UNITS_SPECIAL.DETAILS = 'Y' or UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS |
|
| 2.14 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
| 2.15 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
| 2.16 | FACTOR | Course EFTS Factor | 6 |
PEOPLE_UNITS_SPECIAL.COURSE_EFTS_FACTOR (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR |
|
| 2.17 | EFTS_MTH | EFTS by Month | 84 |
UIO_EFTS.EFTS_MONTH_01-12 and PEOPLE_UNITS_SPECIAL_EFTS.EFTS_MONTH_01-12 for rows that apply to the academic year being reported |
6 chars x12. Numeric with 4 d.p. e.g. 0.0100 |
| 2.18 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 2.19 | CONSORTIUM | Consortium | 6 | ||
| 2.20 | ITE_SECTOR | ITE Sector | 1 | ||
| 2.21 | ITE_SUBJECT | ITE Subject | 19 | ||
| 2.22 | MANAAPPR | Apprenticeships | 1 | ENROLLED_AS_MGD_APPSHIP | |
| 2.23 | SECONDARY_SCHOOL_PROG_INDICATOR | Secondary School Programme Indicator | 1 | SECONDARY_SCHOOL_PROG_INDICATOR | |
| 2.24 | ACTUAL_COURSE_FEE | Actual Course Fee | 8 | ACTUAL_COURSE_FEE |
Course Register file - SDR 2025+
The fields in ebs that are mapped for the Course Register file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 3.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 3.2 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 3.3 | CTITLE | Course Title | 75 | UNIT_INSTANCE_OCCURRENCES.LONG_DESCRIPTION if not null else UNIT_INSTANCES.FES_LONG_DESCRIPTION |
Left Justify Truncate to 75 chars |
| 3.4 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE |
This is the 'home' qualification code. Left Justify |
| 3.5 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
| 3.6 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
| 3.7 | REGISTERLEVEL | Level on the NZ Qualifications and Credentials | 1 | UNIT_INSTANCES.SDR_REGISTER_LEVEL | |
| 3.8 | CREDIT | Credit | 3 | UNIT_INSTANCES.COURSE_CREDITS | |
| 3.9 | CATEGORY | Funding Category | 2 | UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS | |
| 3.10 | FACTOR | Course EFTS Factor |
6 | UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR | |
| 3.11 | FEE | Course Tuition Fee | 10 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
| 3.12 | PBRF Eligible | PBRF Eligible Course Indicator | 1 | UNIT_INSTANCES.SDR_PBRF_ELIGIBLE | |
| 3.13 | FOREIGN_FEE* | Tuition fee paid by international fee-paying student | 10 |
If web_config parameter SDRForeignFeeOutput = 'N' THEN Sum (FEE_VALUES.OVERSEAS_AMOUNT) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year or are null |
GST not included Right Justify |
| 3.14 | CCCOSTS Fee | Compulsory Course Costs Fee | 10 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'C' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
| 3.15 | EXEMPT | Course Exemption from AMFM | 1 | UNIT_INSTANCES.EXEMPT_INDICATOR | |
| 3.16 | DISC_COURSE_TUITUON_FEE | Discounted Course Tuition Fee | 8 | DISC_COURSE_TUITUON_FEE | |
| 3.17 | DISC_COMPULSORY_CRS_FEE | Discounted Compulsory Course Costs Fee | 8 | DISC_COMPULSORY_CRS_COST_FEE | |
| 3.18 | LEARNING_HOURS | Learning Hours | 6 | LEARNING_HOURS | |
| 3.19 | VOLUME_RESEARCH_FACTOR | Volume Research Factor | 5 | VOLUME_RESEARCH_FACTOR |
Qualification Completion file - SDR 2025+
The fields in ebs that are mapped for the Qualification Completion file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 4.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 4.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 4.3 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 4.4 | QUAL | Qualification Code | 6 |
ATTAINMENTS.SDR_QUALIFICATION_CODE if not null UNIT_INSTANCES.SDR_QUALIFICATION_CODE via PEOPLE_UNITS.UIO_ID of ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
| 4.5 | YR_REQ_MET | Year Requirements Met | 4 | ATTAINMENTS.YEAR_REQUIREMENTS_MET | YYYY |
| 1.24 | IRD_NUMBER | IRD Number | 9 | IRD_NO | Note that if the IRD number is only 8 digits, then a leading zero will be added to the output. Hyphens are also added in the output. |
| 1.25 | QUALIFICATION_COMPLETION_DATE | Qualification Completion Date | 10 | ATTAINMENTS.DATE_AWARDED | Date format: DD/MM/YYYY. |
| 1.26 | LINKED_QUALIFICATION_FOR_FEES_FREE | Linked Qualification for Fees Free | 6 | LINKED_QUALIFICATION_FOR_FEES_FREE | The value should be a six alpha-numeric code as on the SDR Qualifications Register which uniquely identifies a quality assured qualification. |
Course Completion file - SDR 2025+
The fields in ebs that are mapped for the Course Completion file are described in the following table.
| Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
|---|---|---|---|---|---|
| 5.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
| 5.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
| 5.3 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
| 5.4 | COMPLETE | Student Course Completion indicator | 1 |
PROGRESS_CODES.SDR_COMPLETION_INDICATOR for record linked to PEOPLE_UNITS.PROGRESS_CODE If code is '0or1' then use '1' if Extract Date <= CRS_END else '0' |
|
| 5.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_START_DATE |
DDMMYYYY |
| 5.6 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
| 5.7 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_END_DATE |
DDMMYYYY |
| 5.8 | PBRF_CRS_COMP_YR | PBRF Course Completion Year | 4 | IF COMPLETE is 2 or 3 and UNIT_INSTANCES.SDR_PBRF_ELIGIBLE is not blank or 'X' then Year component of PEOPLE_UNITS.PROGRESS_DATE | YYYY |